-- GDN Edit Deletion Stop Entry
INSERT INTO TableRelationships (TableName,PrimaryKey,ForeignTableName,ForeignKey,ErrorMessage) VALUES ('Invoice_GDN','BLNo','Invoice_SSP','BENo','This GDN Invoice is used in SSP Invoice / System Vouchers.')

--------------------------------------------------------

USE [Exp]
GO
/****** Object:  Table [dbo].[Invoice_Air]    Script Date: 08/11/2020 13:51:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Invoice_Air](
	[Inv_AirID] [bigint] IDENTITY(1,1) NOT NULL,
	[Inv_AirDate] [datetime] NOT NULL,
	[Inv_AirVNo] [varchar](16) NOT NULL,
	[SessionID] [smallint] NOT NULL,
	[Remarks] [varchar](150) NULL,
	[ReadOnly] [bit] NOT NULL CONSTRAINT [DF_Invoice_Air_ReadOnly]  DEFAULT ((0)),
	[LoginID] [int] NOT NULL,
	[HostName] [varchar](50) NULL CONSTRAINT [DF_Invoice_Air_HostName]  DEFAULT (host_name()),
	[EntryDateTime] [datetime] NULL CONSTRAINT [DF_Invoice_Air_EntryDateTime]  DEFAULT (getdate()),
	[ModifyID] [int] NULL,
	[ModifyHostName] [varchar](50) NULL CONSTRAINT [DF_Invoice_Air_ModifyHostName]  DEFAULT (host_name()),
	[ModifyDateTime] [datetime] NULL CONSTRAINT [DF_Invoice_Air_ModifyDateTime]  DEFAULT (getdate()),
	[AWBDate] [datetime] NULL,
	[ReturnDate] [datetime] NULL,
	[BankDate] [varchar](100) NULL,
	[ExporterID] [int] NULL,
	[SupplierID] [int] NULL,
	[ConsigneeID] [int] NULL,
	[SubPartyID] [smallint] NULL,
	[AgentID] [int] NULL,
	[BankID] [int] NULL,
	[TransporterID] [int] NULL,
	[StatusID] [smallint] NULL,
	[GD] [varchar](50) NULL,
	[AWBNo] [varchar](50) NULL,
	[FlightNo] [varchar](50) NULL,
	[Currency] [varchar](50) NOT NULL,
	[BankRef] [varchar](100) NULL,
	[EFormNo] [varchar](200) NULL,
	[SumQTY] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_Air_SumPkg]  DEFAULT ((0)),
	[SumNetWT] [decimal](15, 4) NOT NULL CONSTRAINT [DF_Invoice_Air_SumNetWT]  DEFAULT ((0)),
	[SumGrossWT] [decimal](15, 4) NOT NULL CONSTRAINT [DF_Invoice_Air_SumGrossWT]  DEFAULT ((0)),
	[SumGWTotal] [decimal](15, 4) NOT NULL CONSTRAINT [DF_Invoice_Air_SumGWTotal]  DEFAULT ((0)),
	[SumNetTotal] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_Air_SumQty]  DEFAULT ((0)),
	[SumAmount] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_Air_SumAmount]  DEFAULT ((0)),
	[NetInvoice] [decimal](15, 4) NOT NULL CONSTRAINT [DF_Invoice_Air_NetInvoice]  DEFAULT ((0)),
	[SumRemit] [decimal](15, 4) NOT NULL CONSTRAINT [DF_Invoice_Air_SumRemit]  DEFAULT ((0)),
	[SumFBC] [decimal](15, 4) NOT NULL CONSTRAINT [DF_Invoice_Air_SumFBC]  DEFAULT ((0)),
 CONSTRAINT [PK_Invoice_Air] PRIMARY KEY CLUSTERED 
(
	[Inv_AirID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Invoice_AirEForm]    Script Date: 08/11/2020 13:51:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Invoice_AirEForm](
	[inv_AirEFormID] [bigint] IDENTITY(1,1) NOT NULL,
	[inv_AirID] [bigint] NOT NULL,
	[EFormID] [bigint] NULL,
	[Type] [tinyint] NOT NULL CONSTRAINT [DF_Invoice_AirEForm_Type]  DEFAULT ((0)),
 CONSTRAINT [PK_Invoice_AirEForm] PRIMARY KEY CLUSTERED 
(
	[inv_AirEFormID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Invoice_AirItem]    Script Date: 08/11/2020 13:51:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Invoice_AirItem](
	[inv_AirItemID] [bigint] IDENTITY(1,1) NOT NULL,
	[inv_AirID] [bigint] NOT NULL,
	[StationID] [smallint] NULL,
	[ItemID] [smallint] NULL,
	[VarietyID] [smallint] NULL,
	[LQTY] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_AirItem_LQTY]  DEFAULT ((0)),
	[Type] [tinyint] NOT NULL CONSTRAINT [DF_Invoice_AirItem_Type]  DEFAULT ((0)),
	[DRemarks] [varchar](50) NULL,
 CONSTRAINT [PK_Invoice_AirItem] PRIMARY KEY CLUSTERED 
(
	[inv_AirItemID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Invoice_AirPacking]    Script Date: 08/11/2020 13:51:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Invoice_AirPacking](
	[inv_AirPackID] [bigint] IDENTITY(1,1) NOT NULL,
	[inv_AirID] [bigint] NOT NULL,
	[ShipMarkID] [smallint] NULL,
	[PackageID] [smallint] NULL,
	[ItemID] [smallint] NULL,
	[QTY] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_AirPacking_QTY]  DEFAULT ((0)),
	[NetWT] [decimal](15, 4) NOT NULL CONSTRAINT [DF_Invoice_AirPacking_NetWT]  DEFAULT ((0)),
	[GrossWT] [decimal](15, 4) NOT NULL CONSTRAINT [DF_Invoice_AirPacking_GrossWT]  DEFAULT ((0)),
	[GWTotal] [decimal](15, 4) NOT NULL CONSTRAINT [DF_Invoice_AirPacking_GWTotal]  DEFAULT ((0)),
	[NetTotal] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_AirPacking_NetTotal]  DEFAULT ((0)),
	[Rate] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_AirPacking_Rate]  DEFAULT ((0)),
	[Amount] [numeric](15, 4) NOT NULL,
	[Type] [tinyint] NOT NULL,
	[ItemRemarks] [varchar](30) NULL,
	[RateRemarks] [varchar](30) NULL,
	[RateType] [varchar](30) NULL,
	[PRemarks] [varchar](50) NULL,
	[PAmount] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_AirPacking_PAmount]  DEFAULT ((0)),
 CONSTRAINT [PK_Invoice_AirPacking] PRIMARY KEY CLUSTERED 
(
	[inv_AirPackID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Invoice_AirRemit]    Script Date: 08/11/2020 13:51:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Invoice_AirRemit](
	[inv_AirRemitID] [bigint] IDENTITY(1,1) NOT NULL,
	[inv_AirID] [bigint] NOT NULL,
	[BankID] [int] NULL,
	[Remit] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_AirRemit_Remit]  DEFAULT ((0)),
	[FBC] [numeric](15, 4) NOT NULL CONSTRAINT [DF_Invoice_AirRemit_FBC]  DEFAULT ((0)),
	[Type] [tinyint] NOT NULL CONSTRAINT [DF_Invoice_AirRemit_Type]  DEFAULT ((0)),
	[BankDate] [datetime] NOT NULL,
	[EPRC] [varchar](100) NULL,
 CONSTRAINT [PK_Invoice_AirRemit] PRIMARY KEY CLUSTERED 
(
	[inv_AirRemitID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF